How to: Copy a table to another database.
Solution:
Select the table in the Database window, use the 'Copy' command under the 'Edit' menu, open the database to which to copy the table, and use the 'Paste' command under the 'Edit' menu.
1) If the Database window is not active, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Select the table to copy from the list.
4) Select the 'Edit' menu and select 'Copy'. (The selected table is copied to the Clipboard.)
5) Close the open database, and open the database to which to copy the table:
NOTE: If the second database is opened before the first is closed, the first database will be automatically closed.
a) Make sure the Database window is displayed.
b) Select the 'File' menu and select 'Close' to close the open database.
c) Open the database to which to copy the table:
1] Select the 'File' menu and select 'Open Database...'. (The Open dialog box appears.)
2] Select the folder containing the desired database from the 'Look in' drop-down list.
3] Select the desired database from the 'Look in' list.
4] Click 'Open'. (The desired database opens.)
6) Make sure the Database window is displayed.
7) Select the 'Edit' menu and select 'Paste'. (The Paste Table As dialog box appears.)
Paste Table As dialog box
8) Type a name for the new copy of the table in the 'Table Name' box.
9) Select one of the radio buttons in the 'Paste Options' group, depending on how the table is to be pasted.
10) Click 'OK'.
NOTE: When a table is copied, any properties associated with the table are also copied.